insert overwrite table yl_ods.yl_tmsnew_tms_vehicle partition(dt)
select
id
,plate_number
,vehicle_belong_code
,vehicle_belong_name
,carrier_id
,carrier_name
,carrier_type
,belong_network_code
,belong_network_name
,vehicle_type_code
,vehicle_type_name
,vehicle_body_code
,vehicle_body_name
,vin
,engine_no
,audit_status
,audit_remark
,audit_id
,auditer
,audit_date
,vehicle_class_id
,vehicle_class_name
,inside_length
,inside_width
,inside_height
,outside_length
,outside_width
,outside_height
,curb_weight
,load_weight
,vehicle_volume
,nuclear_load_num
,total_weight
,tyre_number
,axle_number
,vehicle_origin
,vehicle_brand
,emission_standards
,vehicle_door_cnt
,launch_date
,down_date
,online_status
,fuel_name
,fuel_no
,skeleton_brand
,trailer_type
,saddle_model
,saddle_type
,gas_type
,box_type
,scrap_date
,is_outage
,is_refitted
,null as main_driver
,null as main_tel
,null as copilot_driver
,null as copilot_tel
,null as driving_license_path
,null as transportation_license_path
,null as other_license_path
,null as insurance_commercial_path
,null as insurance_goods_path
,null as insurance_compulsory_path
,null as register_date
,null as driving_license_tip
,null as driving_license_contact
,null as operation_check_date
,null as driving_license_check_date
,null as insurance_commercial_date
,null as insurance_goods_date
,null as insurance_compulsory_date
,create_by
,create_by_name
,create_time
,update_by
,update_by_name
,update_time
,dt
from jms_ods.yl_tmsnew_tms_vehicle
where dt = '{{ execution_date | cst_ds }}' ;